package com.ruoyi.common.utils.jacob;

import com.jacob.activeX.ActiveXComponent;
import com.jacob.com.ComThread;
import com.jacob.com.Dispatch;
import com.jacob.com.Variant;

import java.util.List;

/**
 * @ClassName MSWordManager
 * @Description TODO
 * @Author luguanqing
 * @Date 2021/3/19 8:35
 * @Version 1.0
 */
public class MSWordManager {

    //word文档
    private Dispatch doc;

    //word运行程序对象
    private ActiveXComponent word;

    //word文档集合
    private Dispatch documents;

    //选定范围或者插入点
    private Dispatch selection;

    private boolean saveOnExit = true;

    public MSWordManager(){
        ComThread.InitSTA();
        if(word == null){
            word = new ActiveXComponent("Word.Appliction");
            word.setProperty("Visible", new Variant(false));
        }
        if(documents == null){
            documents = word.getProperty("Documents").toDispatch();
        }
    }

    //设置退出参数
    public void setSaveOnExit(boolean saveOnExit){
        this.saveOnExit = saveOnExit;
    }

    //创建新的word文档
    public void createNewDocument(){
        doc = Dispatch.call(documents, "Add").toDispatch();
        selection = Dispatch.get(word, "Selection").toDispatch();
    }

    //关闭当前文档
    public void closeDocument(){
        if(doc != null){
            Dispatch.call(doc, "Save");
            Dispatch.call(doc, "Close", new Variant(saveOnExit));
            doc = null;
        }
    }


    //打开一个已存在的word
    public void openDocument(String docPath){
        closeDocument();
        doc = Dispatch.call(documents, "Open", docPath).toDispatch();
        selection = Dispatch.get(word, "Selection").toDispatch();
    }

    /**
     * 选定内容插入点或向上移动
     */
    public void moveUp(int pos){
        if(selection == null) {
            selection = Dispatch.get(word, "Selection").toDispatch();
        }
        for(int i = 0; i < pos; i++){
            Dispatch.call(selection, "MoveUp");
        }
    }

    /**
     * 把选定内容或者插入点向下移动
     */
    public void moveDown(int pos){
        if(selection == null){
            selection = Dispatch.get(word, "Selection").toDispatch();
        }
        for (int i = 0; i < pos; i++){
            Dispatch.call(selection, "MoveDown");
        }
    }

    /**
     * 把选定内容或者插入点向左移动
     */
    public void moveLeft(int pos){
        if(selection == null){
            selection = Dispatch.get(word, "Selection").toDispatch();
        }
        for (int i = 0; i < pos; i++){
            Dispatch.call(selection, "moveLeft");
        }
    }

    /**
     * 把选定内容或者插入点向右移动
     */
    public void moveRight(int pos){
        if(selection == null){
            selection = Dispatch.get(word, "Selection").toDispatch();
        }
        for (int i = 0; i < pos; i++){
            Dispatch.call(selection, "moveRight");
        }
    }

    /**
     * 把插入点移动到文件首位置
     *
     */
    public void moveStart() {
        if (selection == null) {
            selection = Dispatch.get(word, "Selection").toDispatch();
        }
        Dispatch.call(selection, "HomeKey", new Variant(6));
    }

    public void moveEnd() {
        if (selection == null) {
            selection = Dispatch.get(word, "Selection").toDispatch();
        }
        Dispatch.call(selection, "EndKey", new Variant(6));
    }

    /**
     * 从选定内容或插入点开始查找文本
     * @param toFindText 要查找的文本
     * @return boolean true 查找到并选中该文本， false 为查找到文本
     */
    public boolean find(String toFindText){
        if (toFindText == null || toFindText.equals("")) {
            return false;
        }
        // 从selection所在位置开始查询
        Dispatch find = word.call(selection, "Find").toDispatch();
        // 设置要查找的内容
        Dispatch.put(find, "Text", toFindText);
        // 向前查找
        Dispatch.put(find, "Forward", "True");
        // 设置格式
        Dispatch.put(find, "Format", "True");
        // 大小写匹配
        Dispatch.put(find, "MatchCase", "True");
        // 全字匹配
        Dispatch.put(find, "MatchWholeWord", "True");
        // 查找并选中
        return Dispatch.call(find, "Execute").getBoolean();
    }

    /**
     * 把选定选定内容设定为替换文本
     *
     * @param toFindText
     *            查找字符串
     * @param newText
     *            要替换的内容
     * @return
     */
    public boolean replaceText(String toFindText, String newText) {
        if (!find(toFindText)){
            return false;
        }
        Dispatch.put(selection, "Text", newText);
        return true;
    }

    /**
     * 全局替换文本
     *
     * @param toFindText
     *            查找字符串
     * @param newText
     *            要替换的内容
     */
    public void replaceAllText(String toFindText, String newText) {
        while (find(toFindText)) {
            Dispatch.put(selection, "Text", newText);
            Dispatch.call(selection, "MoveRight");
        }
    }

    /**
     * 在当前插入点插入字符串
     *
     * @param newText
     *            要插入的新字符串
     */
    public void insertText(String newText) {
        Dispatch.put(selection, "Text", newText);
    }

    /**
     *
     * @param toFindText
     *            要查找的字符串
     * @param imagePath
     *            图片路径
     * @return
     */
    public boolean replaceImage(String toFindText, String imagePath) {
        if (!find(toFindText)) {
            return false;
        }
        Dispatch.call(Dispatch.get(selection, "InLineShapes").toDispatch(), "AddPicture", imagePath);
        return true;
    }

    /**
     * 全局替换图片
     *
     * @param toFindText
     *            查找字符串
     * @param imagePath
     *            图片路径
     */
    public void replaceAllImage(String toFindText, String imagePath) {
        while (find(toFindText)) {
            Dispatch.call(Dispatch.get(selection, "InLineShapes").toDispatch(), "AddPicture", imagePath);
            Dispatch.call(selection, "MoveRight");
        }
    }

    /**
     * 在当前插入点插入图片
     *
     * @param imagePath
     *            图片路径
     */
    public void insertImage(String imagePath) {
        Dispatch.call(Dispatch.get(selection, "InLineShapes").toDispatch(), "AddPicture", imagePath);
    }

    /**
     * 合并单元格
     *
     * @param tableIndex
     * @param fstCellRowIdx
     * @param fstCellColIdx
     * @param secCellRowIdx
     * @param secCellColIdx
     */
    public void mergeCell(int tableIndex, int fstCellRowIdx, int fstCellColIdx, int secCellRowIdx, int secCellColIdx) {
        // 所有表格
        Dispatch tables = Dispatch.get(doc, "Tables").toDispatch();
        // 要填充的表格
        Dispatch table = Dispatch.call(tables, "Item", new Variant(tableIndex)).toDispatch();
        Dispatch fstCell = Dispatch.call(table, "Cell", new Variant(fstCellRowIdx), new Variant(fstCellColIdx))
                .toDispatch();
        Dispatch secCell = Dispatch.call(table, "Cell", new Variant(secCellRowIdx), new Variant(secCellColIdx))
                .toDispatch();
        Dispatch.call(fstCell, "Merge", secCell);
    }

    /**
     * 在指定的单元格里填写数据
     *
     * @param tableIndex
     * @param cellRowIdx
     * @param cellColIdx
     * @param txt
     */
    public void putTxtToCell(int tableIndex, int cellRowIdx, int cellColIdx, String txt) {
        // 所有表格
        Dispatch tables = Dispatch.get(doc, "Tables").toDispatch();
        // 要填充的表格
        Dispatch table = Dispatch.call(tables, "Item", new Variant(tableIndex)).toDispatch();
        Dispatch cell = Dispatch.call(table, "Cell", new Variant(cellRowIdx), new Variant(cellColIdx)).toDispatch();
        Dispatch.call(cell, "Select");
        Dispatch.put(selection, "Text", txt);
    }

    /**
     * 在当前文档拷贝数据
     *
     * @param toCopyText
     */
    public void copy(String toCopyText) {
        moveStart();
        if (this.find(toCopyText)) {
            Dispatch textRange = Dispatch.get(selection, "Range").toDispatch();
            Dispatch.call(textRange, "Copy");
        }
    }

    /**
     * 在当前文档粘帖剪贴板数据
     *
     * @param pos
     */
    public void paste(String pos) {
        moveStart();
        if (this.find(pos)) {
            Dispatch textRange = Dispatch.get(selection, "Range").toDispatch();
            Dispatch.call(textRange, "Paste");
        }
    }

    /**
     * 在当前文档指定的位置拷贝表格
     *
     * @param pos
     *            当前文档指定的位置
     * @param tableIndex
     *            被拷贝的表格在word文档中所处的位置
     */
    public void copyTable(String pos, int tableIndex) {
        Dispatch tables = Dispatch.get(doc, "Tables").toDispatch();
        Dispatch table = Dispatch.call(tables, "Item", new Variant(tableIndex)).toDispatch();
        Dispatch range = Dispatch.get(table, "Range").toDispatch();
        Dispatch.call(range, "Copy");
        if (this.find(pos)) {
            Dispatch textRange = Dispatch.get(selection, "Range").toDispatch();
            Dispatch.call(textRange, "Paste");
        }
    }

    /**
     * 在当前文档末尾拷贝来自另一个文档中的段落
     *
     * @param anotherDocPath  另一个文档的磁盘路径
     * @param paragraphIndex 被拷贝的段落在另一格文档中的序号(从1开始)
     */
    public void copyParagraphFromAnotherDoc(String anotherDocPath, int paragraphIndex) {
        Dispatch wordContent = Dispatch.get(doc, "Content").toDispatch(); // 取得当前文档的内容
        Dispatch.call(wordContent, "InsertAfter", "$selection$"); // 插入特殊符定位插入点
        copyParagraphFromAnotherDoc(anotherDocPath, paragraphIndex, "$selection$");
    }

    /**
     * 在当前文档指定的位置拷贝来自另一个文档中的段落
     *
     * @param anotherDocPath 另一个文档的磁盘路径
     * @param paragraphIndex  被拷贝的段落在另一格文档中的序号(从1开始)
     * @param pos  当前文档指定的位置
     */
    public void copyParagraphFromAnotherDoc(String anotherDocPath, int paragraphIndex, String pos) {
        Dispatch doc2 = null;
        try {
            doc2 = Dispatch.call(documents, "Open", anotherDocPath).toDispatch();
            Dispatch paragraphs = Dispatch.get(doc2, "Paragraphs").toDispatch();

            Dispatch paragraph = Dispatch.call(paragraphs, "Item", new Variant(paragraphIndex)).toDispatch();
            Dispatch range = Dispatch.get(paragraph, "Range").toDispatch();
            Dispatch.call(range, "Copy");
            if (this.find(pos)) {
                Dispatch textRange = Dispatch.get(selection, "Range").toDispatch();
                Dispatch.call(textRange, "Paste");
            }
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            if (doc2 != null) {
                Dispatch.call(doc2, "Close", new Variant(saveOnExit));
                doc2 = null;
            }
        }
    }

    /**
     * 在当前文档指定的位置拷贝来自另一个文档中的表格
     *
     * @param anotherDocPath
     *            另一个文档的磁盘路径
     * @param tableIndex
     *            被拷贝的表格在另一格文档中的序号(从1开始)
     * @param pos
     *            当前文档指定的位置
     */
    public void copyTableFromAnotherDoc(String anotherDocPath, int tableIndex, String pos) {
        Dispatch doc2 = null;
        try {
            doc2 = Dispatch.call(documents, "Open", anotherDocPath).toDispatch();
            Dispatch tables = Dispatch.get(doc2, "Tables").toDispatch();
            Dispatch table = Dispatch.call(tables, "Item", new Variant(tableIndex)).toDispatch();
            Dispatch range = Dispatch.get(table, "Range").toDispatch();
            Dispatch.call(range, "Copy");
            if (this.find(pos)) {
                Dispatch textRange = Dispatch.get(selection, "Range").toDispatch();
                Dispatch.call(textRange, "Paste");
            }
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            if (doc2 != null) {
                Dispatch.call(doc2, "Close", new Variant(saveOnExit));
                doc2 = null;
            }
        }
    }

    /**
     * 在当前文档指定的位置拷贝来自另一个文档中的图片
     *
     * @param anotherDocPath
     *            另一个文档的磁盘路径
     * @param shapeIndex
     *            被拷贝的图片在另一格文档中的位置
     * @param pos
     *            当前文档指定的位置
     */
    public void copyImageFromAnotherDoc(String anotherDocPath, int shapeIndex, String pos) {
        Dispatch doc2 = null;
        try {
            doc2 = Dispatch.call(documents, "Open", anotherDocPath).toDispatch();
            Dispatch shapes = Dispatch.get(doc2, "InLineShapes").toDispatch();
            Dispatch shape = Dispatch.call(shapes, "Item", new Variant(shapeIndex)).toDispatch();
            Dispatch imageRange = Dispatch.get(shape, "Range").toDispatch();
            Dispatch.call(imageRange, "Copy");
            if (this.find(pos)) {
                Dispatch textRange = Dispatch.get(selection, "Range").toDispatch();
                Dispatch.call(textRange, "Paste");
            }
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            if (doc2 != null) {
                Dispatch.call(doc2, "Close", new Variant(saveOnExit));
                doc2 = null;
            }
        }
    }

    /**
     * 创建表格
     *
     * @param numCols 列数
     * @param numRows 行数
     */
    public void createTable(int numCols, int numRows) {
        Dispatch tables = Dispatch.get(doc, "Tables").toDispatch();
        Dispatch range = Dispatch.get(selection, "Range").toDispatch();
        Dispatch newTable = Dispatch.call(tables, "Add", range, new Variant(numRows), new Variant(numCols))
                .toDispatch();
        Dispatch.call(selection, "MoveRight");
        moveEnd();
    }

    /**
     * 在指定行前面增加行
     *
     * @param tableIndex
     *            word文件中的第N张表(从1开始)
     * @param rowIndex
     *            指定行的序号(从1开始)
     */
    public void addTableRow(int tableIndex, int rowIndex) {
        // 所有表格
        Dispatch tables = Dispatch.get(doc, "Tables").toDispatch();
        // 要填充的表格
        Dispatch table = Dispatch.call(tables, "Item", new Variant(tableIndex)).toDispatch();
        // 表格的所有行
        Dispatch rows = Dispatch.get(table, "Rows").toDispatch();
        Dispatch row = Dispatch.call(rows, "Item", new Variant(rowIndex)).toDispatch();
        Dispatch.call(rows, "Add", new Variant(row));
    }

    /**
     * 在第1行前增加一行
     *
     * @param tableIndex
     *            word文档中的第N张表(从1开始)
     */
    public void addFirstTableRow(int tableIndex) {
        // 所有表格
        Dispatch tables = Dispatch.get(doc, "Tables").toDispatch();
        // 要填充的表格
        Dispatch table = Dispatch.call(tables, "Item", new Variant(tableIndex)).toDispatch();
        // 表格的所有行
        Dispatch rows = Dispatch.get(table, "Rows").toDispatch();
        Dispatch row = Dispatch.get(rows, "First").toDispatch();
        Dispatch.call(rows, "Add", new Variant(row));
    }

    /**
     * 在最后1行前增加一行
     *
     * @param tableIndex
     *            word文档中的第N张表(从1开始)
     */
    public void addLastTableRow(int tableIndex) {
        // 所有表格
        Dispatch tables = Dispatch.get(doc, "Tables").toDispatch();
        // 要填充的表格
        Dispatch table = Dispatch.call(tables, "Item", new Variant(tableIndex)).toDispatch();
        // 表格的所有行
        Dispatch rows = Dispatch.get(table, "Rows").toDispatch();
        Dispatch row = Dispatch.get(rows, "Last").toDispatch();
        Dispatch.call(rows, "Add", new Variant(row));
    }

    /**
     * 增加一行
     *
     * @param tableIndex
     *            word文档中的第N张表(从1开始)
     */
    public void addRow(int tableIndex) {
        Dispatch tables = Dispatch.get(doc, "Tables").toDispatch();
        // 要填充的表格
        Dispatch table = Dispatch.call(tables, "Item", new Variant(tableIndex)).toDispatch();
        // 表格的所有行
        Dispatch rows = Dispatch.get(table, "Rows").toDispatch();
        Dispatch.call(rows, "Add");
    }

    /**
     * 增加一列
     *
     * @param tableIndex
     *            word文档中的第N张表(从1开始)
     */
    public void addCol(int tableIndex) {
        // 所有表格
        Dispatch tables = Dispatch.get(doc, "Tables").toDispatch();
        // 要填充的表格
        Dispatch table = Dispatch.call(tables, "Item", new Variant(tableIndex)).toDispatch();
        // 表格的所有行
        Dispatch cols = Dispatch.get(table, "Columns").toDispatch();
        Dispatch.call(cols, "Add").toDispatch();
        Dispatch.call(cols, "AutoFit");
    }

    /**
     * 在指定列前面增加表格的列
     *
     * @param tableIndex
     *            word文档中的第N张表(从1开始)
     * @param colIndex
     *            指定列的序号 (从1开始)
     */
    public void addTableCol(int tableIndex, int colIndex) {
        // 所有表格
        Dispatch tables = Dispatch.get(doc, "Tables").toDispatch();
        // 要填充的表格
        Dispatch table = Dispatch.call(tables, "Item", new Variant(tableIndex)).toDispatch();
        // 表格的所有行
        Dispatch cols = Dispatch.get(table, "Columns").toDispatch();
        System.out.println(Dispatch.get(cols, "Count"));
        Dispatch col = Dispatch.call(cols, "Item", new Variant(colIndex)).toDispatch();
        // Dispatch col = Dispatch.get(cols, "First").toDispatch();
        Dispatch.call(cols, "Add", col).toDispatch();
        Dispatch.call(cols, "AutoFit");
    }

    /**
     * 在第1列前增加一列
     *
     * @param tableIndex
     *            word文档中的第N张表(从1开始)
     */
    public void addFirstTableCol(int tableIndex) {
        Dispatch tables = Dispatch.get(doc, "Tables").toDispatch();
        // 要填充的表格
        Dispatch table = Dispatch.call(tables, "Item", new Variant(tableIndex)).toDispatch();
        // 表格的所有行
        Dispatch cols = Dispatch.get(table, "Columns").toDispatch();
        Dispatch col = Dispatch.get(cols, "First").toDispatch();
        Dispatch.call(cols, "Add", col).toDispatch();
        Dispatch.call(cols, "AutoFit");
    }

    /**
     * 在最后一列前增加一列
     *
     * @param tableIndex
     *            word文档中的第N张表(从1开始)
     */
    public void addLastTableCol(int tableIndex) {
        Dispatch tables = Dispatch.get(doc, "Tables").toDispatch();
        // 要填充的表格
        Dispatch table = Dispatch.call(tables, "Item", new Variant(tableIndex)).toDispatch();
        // 表格的所有行
        Dispatch cols = Dispatch.get(table, "Columns").toDispatch();
        Dispatch col = Dispatch.get(cols, "Last").toDispatch();
        Dispatch.call(cols, "Add", col).toDispatch();
        Dispatch.call(cols, "AutoFit");
    }

    /**
     * 自动调整表格
     *
     */
    public void autoFitTable() {
        Dispatch tables = Dispatch.get(doc, "Tables").toDispatch();
        int count = Dispatch.get(tables, "Count").toInt();
        for (int i = 0; i < count; i++) {
            Dispatch table = Dispatch.call(tables, "Item", new Variant(i + 1)).toDispatch();
            Dispatch cols = Dispatch.get(table, "Columns").toDispatch();
            Dispatch.call(cols, "AutoFit");
        }
    }

    /**
     * 调用word里的宏以调整表格的宽度,其中宏保存在document下
     *
     */
    public void callWordMacro() {
        Dispatch tables = Dispatch.get(doc, "Tables").toDispatch();
        int count = Dispatch.get(tables, "Count").toInt();
        Variant vMacroName = new Variant("Normal.NewMacros.tableFit");
        Variant vParam = new Variant("param1");
        Variant para[] = new Variant[] { vMacroName };
        for (int i = 0; i < para.length; i++) {
            Dispatch table = Dispatch.call(tables, "Item", new Variant(i + 1)).toDispatch();
            Dispatch.call(table, "Select");
            Dispatch.call(word, "Run", "tableFitContent");
        }
    }

    /**
     * 设置当前选定内容的字体
     *
     * @param bold
     * @param italic
     * @param underLine 下划线
     * @param colorSize 字体颜色
     * @param size 字体大小
     * @param name 字体名称
     */
    public void setFont(boolean bold, boolean italic, boolean underLine, String colorSize, String size, String name) {
        Dispatch font = Dispatch.get(selection, "Font").toDispatch();
        Dispatch.put(font, "Name", new Variant(name));
        Dispatch.put(font, "Bold", new Variant(bold));
        Dispatch.put(font, "Italic", new Variant(italic));
        Dispatch.put(font, "Underline", new Variant(underLine));
        Dispatch.put(font, "Color", colorSize);
        Dispatch.put(font, "Size", size);
    }

    /**
     * 文件保存或另存为
     *
     * @param savePath
     *            保存或另存为路径
     */
    public void save(String savePath) {
        Dispatch.call((Dispatch) Dispatch.call(word, "WordBasic").getDispatch(), "FileSaveAs", savePath);
    }

    /**
     * 关闭全部应用
     *
     */
    public void close() {
        closeDocument();
        if (word != null) {
            Dispatch.call(word, "Quit");
            word = null;
        }
        selection = null;
        documents = null;
    }

    /**
     * 打印当前word文档
     *
     */
    public void printFile() {
        if (doc != null) {
            Dispatch.call(doc, "PrintOut");
        }
    }
    /**
     * 插入word图表
     * 包含组合图表
     * t 图表类型
     * list 图表数据源
     * charttitletext 图表标题
     */
    public void inLine(int t, List<Object[]> list, String chartTitleText) {
        // List<Object[]> list=new ArrayList<Object[]>();
        // Object[]
        // o={"","广州电力设计院","广州汇隽电力工程设计有限公司","广州南方电力建设集团电力设计有限公司","广州市电力工程设计有限公司","广州新研电力设计有限公司"};
        // Object[] o1={"前三季度平均值","68","139","84","124","42"};
        // Object[] o2={"第四季度","163","247","13","363","66"};
        // list.add(o);
        // list.add(o1);
        // list.add(o2);

        // 插入ole对象
        Dispatch inLine = Dispatch.get(selection, "InlineShapes").toDispatch();
        Dispatch graph = Dispatch.call(inLine, "AddOLEObject", "MSGraph.Chart.8").toDispatch();
        // 设置图表的高度
        Dispatch.put(graph, "Height", new Variant(300.00));
        // 设置表的宽度
        Dispatch.put(graph, "Width", new Variant(400.00));
        // 格式化图表
        Dispatch oleFormat = Dispatch.call(graph, "OLEFormat").toDispatch();
        Dispatch obj = Dispatch.call(oleFormat, "Object").toDispatch();
        // 设置背景墙颜色
        Dispatch walls = Dispatch.get(obj, "Walls").toDispatch();
        Dispatch interiorWall = Dispatch.get(walls, "Interior").toDispatch();
        Dispatch.put(interiorWall, "ColorIndex", new Variant(2));
        // 设置图表区的外边框颜色和背景色
        Dispatch chartArea = Dispatch.get(obj, "ChartArea").toDispatch();
        Dispatch interior = Dispatch.get(chartArea, "Interior").toDispatch();
        Dispatch.put(interior, "ColorIndex", new Variant(2));
        Dispatch border = Dispatch.get(chartArea, "Border").toDispatch();
        Dispatch.put(border, "ColorIndex", new Variant(1));
        Dispatch.put(obj, "HasLegend", new Variant(false));
        Dispatch.put(obj, "HasTitle", new Variant(true));
        // 设置图形的类型
        /*
         * 图形样式 可能的样式有:柱图代码为51,52,53,54,55,56;柱状图还含有堆积图 折线代码为65,66;
         * 饼图代码有70,-4102,5,69;等等)
         */
        Dispatch.put(obj, "ChartType", 51);
        Dispatch SeriesCollection = Dispatch.call(obj, "SeriesCollection", 2).toDispatch();
        Dispatch.put(SeriesCollection, "ChartType", 4);
        // 设置图形Y轴图形样式
        Dispatch axes = Dispatch.call(obj, "Axes", 2).toDispatch();
        Dispatch.put(axes, "HasMajorGridlines", true);// 设置图形的横向网络线是否显示
        // 设置图形左侧坐标轴字体样式
        Dispatch font_y = Dispatch.get(Dispatch.get(axes, "TickLabels").toDispatch(), "Font").toDispatch();
        Dispatch.put(font_y, "Name", "宋体");
        Dispatch.put(font_y, "Size", "9");
        // 设置图标标题
        Dispatch chartTitle = Dispatch.get(obj, "ChartTitle").toDispatch();
        Dispatch.put(chartTitle, "Text", chartTitleText);
        Dispatch font = Dispatch.get(chartTitle, "Font").toDispatch();
        Dispatch.put(font, "Size", "18");
        Dispatch.put(font, "Name", "黑体");
        Dispatch dataSheet = Dispatch.get(obj, "Application").toDispatch();
        Dispatch dataSheet2 = Dispatch.get(dataSheet, "dataSheet").toDispatch();
        // 显示图形的数据表
        Dispatch.put(obj, "HasDataTable", true);
        Dispatch dataTable = Dispatch.get(obj, "DataTable").toDispatch();
        // 设置是否显示数据表的标识（这里设置为显示数据表的标识）
        Dispatch.put(dataTable, "ShowLegendKey", true);
        // 获得数据表对象的字体属性,并设置字体和字号等
        Dispatch fontTable = Dispatch.get(dataTable, "Font").toDispatch();
        Dispatch.put(fontTable, "Name", "宋体");
        Dispatch.put(fontTable, "Size", "9");

        // 得到数据表的单元格
        Dispatch cells = Dispatch.get(dataSheet2, "Cells").toDispatch();
        Dispatch.call(cells, "Clear");
        // for循环添加数据
        for (int i = 0; i < list.size(); i++) {
            Object[] o11 = list.get(i);

            for (int j = 0; j < o11.length; j++) {
                Dispatch item = Dispatch.call(cells, "Item", new Variant(i + 1), new Variant(j + 1)).toDispatch();
                Dispatch.put(item, "value", o11[j]);
            }

        }
        Dispatch.call(graph, "Select"); // 选中图表
        Dispatch ShapeRange = Dispatch.call(graph, "ConvertToShape").toDispatch(); // 取得图片区域
        Dispatch WrapFormat = Dispatch.get(ShapeRange, "WrapFormat").toDispatch(); // 取得图片的格式对象
        Dispatch.put(WrapFormat, "Type", 1);

    }

    public static void main(String args[]) throws Exception {
        MSWordManager word = new MSWordManager();

        word.createNewDocument();

        word.createTable(5, 5);

        word.mergeCell(1, 1, 1, 1, 5);

        word.mergeCell(1, 2, 1, 2, 5);

        word.mergeCell(1, 3, 1, 3, 5);

        word.putTxtToCell(1,1,1,"主题");

        word.putTxtToCell(1,2,1,"时间");

        word.putTxtToCell(1,3,1,"人员");

        word.putTxtToCell(1,4,2,"说话了");

        word.save("c:\\jacobTest.doc");

        System.out.print("请打开c:\\jacobTest.doc查看是否有写word成功!");

    }


}
